Running A Query

Now that you have selected fields and chosen sort options, it is time to run your query.

Click the Run button on the toolbar


    Access displays the resulting query in the query window.

    Look at the Trans column. Note that the records are no longer listed in the order that you entered them. They are sorted first by department, and within each department by description.

    The scroll bar at the bottom of the window allows you to scroll through the different records.

Now you try!